package dbutils;

import java.util.HashMap;
import java.util.Map;

/**
 * @author Xiongx
 * @version 1.0
 * @date 2021/6/29 16:02
 * @since JDK 1.8
 */
public class DataScore {

    //dm
    public static Map<String, String> QA_DJ(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:dm://192.168.246.62:5237/ZZBDJW_QA");
        stringMap.put("username","ZZBDJW_QA");
        stringMap.put("password","ZZBDJW_QA");
        stringMap.put("driver","dm.jdbc.driver.DmDriver");
        return stringMap;
    }


    /**
     * 开发环境
     * @return
     */
    public static Map<String, String> DEV_DJ(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:dm://192.168.246.62:5237/ZZBDJW_DEV");
        stringMap.put("username","ZZBDJW_DEV");
        stringMap.put("password","ZZBDJW_DEV");
        stringMap.put("driver","dm.jdbc.driver.DmDriver");
        return stringMap;
    }


    //mysql
    public static Map<String, String> MY_SQL(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:mysql://localhost:3306/spring-demo?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull");
        stringMap.put("username","root");
        stringMap.put("password","admin");
        stringMap.put("driver","com.mysql.cj.jdbc.Driver");
        return stringMap;
    }

    //mysql
    public static Map<String, String> MY_SQL_LINUX(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:mysql://192.168.217.128:3306/springdemo?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull");
        stringMap.put("username","root");
        stringMap.put("password","123456");
        stringMap.put("driver","com.mysql.cj.jdbc.Driver");
        return stringMap;
    }

    //oracl
    public static Map<String, String> ORACLE(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:oracle:thin:@127.0.0.1:1521/ORCL");
        stringMap.put("username","test");
        stringMap.put("password","test");
        stringMap.put("driver","oracle.jdbc.driver.OracleDriver");
        return stringMap;
    }


    //sqlserver
    public static Map<String, String> sqlServer(){
        Map<String, String> stringMap=new HashMap<>();
        stringMap.put("url","jdbc:sqlserver://xiong\\SQLEXPRESS;DatabaseName=Whir_ezEIP4_swzzb;SelectMethod=cursor");
        stringMap.put("username","SA");
        stringMap.put("password","12345678");
        stringMap.put("driver","com.microsoft.sqlserver.jdbc.SQLServerDriver");
        return stringMap;
    }

}
